<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>赵燕露</Author>
  <LastAuthor>7lQ</LastAuthor>
  <Created>2015-06-05T18:19:00Z</Created>
  <LastSaved>2021-08-04T07:50:45Z</LastSaved>
  <Version>16.00</Version>
 </DocumentProperties>
 <CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <KSOProductBuildVer dt:dt="string">2052-11.3.0.9228</KSOProductBuildVer>
 </CustomDocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>12720</WindowHeight>
  <WindowWidth>23256</WindowWidth>
  <WindowTopX>32767</WindowTopX>
  <WindowTopY>32767</WindowTopY>
  <RefModeR1C1/>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s16">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
  </Style>
  <Style ss:ID="s27">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#000000"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#000000"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#000000"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"
     ss:Color="#000000"/>
   </Borders>
  </Style>
  <Style ss:ID="s75">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Font ss:FontName="等线" x:CharSet="134" ss:Size="12" ss:Color="#000000"
    ss:Bold="1"/>
  </Style>
  <Style ss:ID="s78">
   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
   <Font ss:FontName="等线" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
  </Style>
 </Styles>
 <Worksheet ss:Name=" (PL00002940)">
  <#list data as item>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.3"/>
    <Footer x:Margin="0.3"/>
    <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
   </PageSetup>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>360</HorizontalResolution>
    <VerticalResolution>360</VerticalResolution>
   </Print>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <Activetr>5</Activetr>
     <ActiveCol>2</ActiveCol>
     <RangeSelection>R6C3:R6C12</RangeSelection>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>

  <Table style="text-align: center;vertical-align: middle;font-size: 11px;font-family: 等线;border-style:thin">
   <caption>${item.hedgeNO?if_exists}</caption>
   <Column ss:StyleID="s16" ss:Width="112.2"/>
   <Column ss:StyleID="s16" ss:Width="103.8"/>
   <Column ss:StyleID="s16" ss:Width="62.400000000000006"/>
   <Column ss:StyleID="s16" ss:Width="49.8"/>
   <Column ss:StyleID="s16" ss:Width="99.6"/>
   <Column ss:StyleID="s16" ss:Width="62.400000000000006" ss:Span="2"/>
   <Column ss:Index="9" ss:StyleID="s16" ss:Width="99.6"/>
   <Column ss:StyleID="s16" ss:Width="37.200000000000003"/>
   <Column ss:StyleID="s16" ss:Width="62.400000000000006"/>
   <Column ss:StyleID="s16" ss:Width="49.8"/>
   <Column ss:StyleID="s16" ss:Width="120.60000000000001"/>
   <Column ss:StyleID="s16" ss:Width="62.400000000000006"/>
   <Column ss:StyleID="s16" ss:Width="75"/>
   <Column ss:StyleID="s16" ss:Width="62.400000000000006" ss:Span="1"/>
   <Column ss:Index="18" ss:StyleID="s16" ss:Width="49.8"/>
   <Column ss:StyleID="s16" ss:Width="37.200000000000003"/>
   <Column ss:StyleID="s16" ss:Width="49.8"/>
   <Column ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="174.6"/>
   <tr ss:Height="15.600000000000001">
    <td ss:MergeAcross="19" colspan="20"><Data ss:Type="String">贸易商列表导出详情</Data></td>
   </tr>
   <tr>
    <td><Data ss:Type="String">部门：</Data></td>
    <td ss:Index="3" ss:MergeAcross="15"/>
    <td><Data ss:Type="String">时间：</Data></td>
   </tr>
   <tr>
    <td><Data ss:Type="String">套保编号</Data></td>
    <td ss:MergeAcross="10" ss:StyleID="s78" colspan="11"><Data ss:Type="String">${item.hedgeNO?if_exists}</Data></td>
    <td><Data ss:Type="String">核算日期</Data></td>
    <td ss:MergeAcross="6" ss:StyleID="s78" colspan="7"><Data ss:Type="String">${item.accountDate?date?if_exists}</Data></td>
   </tr>
   <tr>
    <td ss:StyleID="s78"><Data ss:Type="String">${item.excelBusinessStaff?if_exists}</Data></td>
    <td ss:MergeAcross="10" ss:StyleID="s78" colspan="11"><Data ss:Type="String">${item.excelContract?if_exists}</Data></td>
    <td ss:MergeAcross="7" ss:StyleID="s78" colspan="8"><Data ss:Type="String">${item.excelCommodity?if_exists}</Data></td>
   </tr>
   <tr>
    <td ss:StyleID="s78"><Data ss:Type="String">${item.excelPlace?if_exists}</Data></td>
    <td><Data ss:Type="String">保证金比例</Data></td>
    <td ss:MergeAcross="9" ss:StyleID="s78" colspan="10"><Data ss:Type="String">${item.excelMargin?if_exists}</Data></td>
    <td><Data ss:Type="String">现套保比例</Data></td>
    <td ss:MergeAcross="6" ss:StyleID="s78" colspan="7"><Data ss:Type="String">${item.excelHedging?if_exists}</Data></td>
   </tr>
   <tr>
    <td ss:StyleID="s78"><Data ss:Type="String">${item.excelSettlement?if_exists}</Data></td>
    <td><Data ss:Type="String">初始入金</Data></td>
    <td ss:MergeAcross="9" ss:StyleID="s78" colspan="10"><Data ss:Type="String">${item.inTradeMoney?if_exists}</Data></td>
    <td><Data ss:Type="String">出金</Data></td>
    <td ss:MergeAcross="6" ss:StyleID="s78" colspan="7"><Data ss:Type="String">${item.outTradeMoney?if_exists}</Data></td>
   </tr>
   <tr>
    <td><Data ss:Type="String">操作</Data></td>
    <td><Data ss:Type="String">成交编号</Data></td>
    <td><Data ss:Type="String">期货公司</Data></td>
    <td ss:StyleID="s78"><Data ss:Type="String">期货合约</Data></td>
    <td><Data ss:Type="String">开仓仓位（重量）</Data></td>
    <td><Data ss:Type="String">开仓价</Data></td>
    <td ss:StyleID="s78"><Data ss:Type="String">开仓手续费</Data></td>
    <td><Data ss:Type="String">期货收盘价</Data></td>
    <td><Data ss:Type="String">平仓仓位（重量）</Data></td>
    <td><Data ss:Type="String">平仓价</Data></td>
    <td ss:StyleID="s78"><Data ss:Type="String">平仓手续费</Data></td>
    <td><Data ss:Type="String">平仓盈亏</Data></td>
    <td><Data ss:Type="String">合同编号</Data></td>
    <td ss:StyleID="s78"><Data ss:Type="String">合同单据号</Data></td>
    <td><Data ss:Type="String">采购重量</Data></td>
    <td><Data ss:Type="String">初始计价</Data></td>
    <td><Data ss:Type="String">现价</Data></td>
    <td><Data ss:Type="String">销售重量</Data></td>
    <td><Data ss:Type="String">销售价</Data></td>
    <td><Data ss:Type="String">实现盈亏</Data></td>
   </tr>
   <#list item.multiList?if_exists as list>
     <tr>
      <#if (list[0].date)??>
       <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.date?if_exists?date}</Data></td>
       <#else >
       <td></td>
      </#if>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.num?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.account?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.contractId?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.openHoldPositon?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.openPrice?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.openServiceFee?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.closePriceOfFuture?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.closeHoldPositon?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.closePrice?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.closeServiceFee?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[0]?if_exists.offSetGainAndLoss?if_exists}</Data></td>

      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.spotId?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.contractDocumentCode?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.buyTonnage?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.initialPrice?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.marketPrice?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.sellTonnage?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.sellPrice?if_exists}</Data></td>
      <td ss:StyleID="s78"><Data ss:Type="String">${list[1]?if_exists.profitAndLoss?if_exists}</Data></td>
     </tr>
   </#list>

   <tr></tr>
   <tr>
    <td style="border-style: none">
    <td style="border-style: none">
    <td ss:StyleID="s27"><Data ss:Type="String">未平仓期货</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">开仓均价</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">在手持仓盈亏</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">已平仓期货</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">总实现盈亏</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">总盈亏</Data></td>
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td ss:StyleID="s27"><Data ss:Type="String">未销售现货</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">初始均价</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">在手浮动盈亏</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">已销售现货</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">总实现盈亏</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">总盈亏</Data></td>
   </tr>
   <tr>
    <td style="border-style: none">
    <td ss:StyleID="s27"><Data ss:Type="String">合计</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">-55</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">5303.6981132075471</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">-21521.46</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">150</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">-980.54</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">-22502</Data></td>
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td ss:StyleID="s27"><Data ss:Type="Number">0</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">3555.56</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">0</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">180</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">438053.1</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="Number">438053.1</Data></td>
   </tr>
   <tr>
    <td style="border-style: none">
    <td ss:StyleID="s27"><Data ss:Type="String">期现对冲损益</Data></td>
    <td ss:MergeAcross="12" ss:StyleID="s27" colspan="16"><Data ss:Type="Number">415551.1</Data></td>
   </tr>
   <tr></tr>
   <tr></tr>
   <tr ss:Index="15">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td ss:Index="13" ss:StyleID="s27" colspan="7"><Data ss:Type="String">现货交货细节</Data></td>
   </tr>
   <tr>
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td style="border-style: none">
    <td ss:Index="13" ss:StyleID="s27"><Data ss:Type="String">项目号</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">合同单据号</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">交货单号</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">单价</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">数量</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">金额</Data></td>
    <td ss:StyleID="s27"><Data ss:Type="String">交货时间</Data></td>
   </tr>
  </Table>
  </#list>
 </Worksheet>
</Workbook>
